You can make the function more dynamic by passing in a comma-separated list of strings to replace, using a split function (sqlteam.com/forums/topic.asp?TOPIC_ID ... ... <看更多>

REPLACE. 取代字串中的值，C 為字串，A 為被取代的字串，B 為取代後的字串. 語法：REPLACE(C, A, B). sql. 1 2, -- 將o 取代為k ... <看更多>

... <看更多>

string_pattern Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string (''), and must ... ... <看更多>